|
600
|
How can I display the currency only for not empty cells
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Currency")))->PutComputedField(L"len(%0) ? currency(dbl(%0)) : ''");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
var_Items->AddItem("0");
var_Items->PutItemBackColor(var_Items->AddItem(vtMissing),RGB(255,128,128));
var_Items->AddItem("10000.99");
|
|
599
|
Is there a function to display the number of days between two date including the number of hours
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Start")))->PutWidth(32);
spGrid1->GetColumns()->Add(L"End");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Duration")))->PutComputedField(_bstr_t("((1:=int(0:= (date(%1)-date(%0)))) != 0 ? (=:1 + ' day(s)') : '') + (=:1 ? ' ' : '' ) + ((1:=int(0:=((=:0 - =:1 + 1/24/60/60/2)") +
"*24))) != 0 ? =:1 + ' hour(s) ' : '' ) + ((1:=round((=:0 - =:1)*60)) != 0 ? =:1 + ' min(s)' : '')");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem(COleDateTime(2001,1,11,0,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2001,1,14,0,00,00).operator DATE());
h = var_Items->AddItem(COleDateTime(2002,2,22,12,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2002,3,14,13,00,00).operator DATE());
h = var_Items->AddItem(COleDateTime(2003,3,13,0,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2003,4,11,11,00,00).operator DATE());
|
|
598
|
Is there a function to display the number of days between two date including the number of hours
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Start");
spGrid1->GetColumns()->Add(L"End");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Duration")))->PutComputedField(L"\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem(COleDateTime(2001,1,11,0,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2001,1,14,23,00,00).operator DATE());
h = var_Items->AddItem(COleDateTime(2002,2,22,12,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2002,3,14,13,00,00).operator DATE());
h = var_Items->AddItem(COleDateTime(2003,3,13,0,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2003,4,11,11,00,00).operator DATE());
|
|
597
|
How can I display the number of days between two dates
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Start");
spGrid1->GetColumns()->Add(L"End");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Duration")))->PutComputedField(L"(date(%1)-date(%0)) + ' days'");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem(COleDateTime(2001,1,11,0,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2001,1,14,0,00,00).operator DATE());
h = var_Items->AddItem(COleDateTime(2002,2,22,0,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2002,3,14,0,00,00).operator DATE());
h = var_Items->AddItem(COleDateTime(2003,3,13,0,00,00).operator DATE());
var_Items->PutCellValue(h,long(1),COleDateTime(2003,4,11,0,00,00).operator DATE());
|
|
596
|
How can I get second part of the date
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Second")))->PutComputedField(L"sec(date(%0))");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,11,10,10,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,22,11,01,22).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,13,12,23,01).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,14,13,11,59).operator DATE());
|
|
595
|
How can I get minute part of the date
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Minute")))->PutComputedField(L"min(date(%0))");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,11,10,10,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,22,11,01,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,13,12,23,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,14,13,11,00).operator DATE());
|
|
594
|
How can I check the hour part only so I know it was afternoon
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetConditionalFormats()->Add(L"hour(%0)>=12",vtMissing)->PutBold(VARIANT_TRUE);
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Hour")))->PutComputedField(L"hour(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,11,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,22,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,13,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,14,13,00,00).operator DATE());
|
|
593
|
What about a function to get the day in the week, or days since Sunday
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"WeekDay")))->PutComputedField(L"weekday(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,11,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,22,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,13,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,14,13,00,00).operator DATE());
|
|
592
|
Is there any function to get the day of the year or number of days since January 1st
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Day since January 1st")))->PutComputedField(L"yearday(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,11,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,22,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,13,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,14,13,00,00).operator DATE());
|
|
591
|
How can I display only the day of the date
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Day")))->PutComputedField(L"day(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,11,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,22,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,13,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,14,13,00,00).operator DATE());
|
|
590
|
How can I display only the month of the date
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Month")))->PutComputedField(L"month(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,1,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,2,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,3,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,4,13,00,00).operator DATE());
|
|
589
|
How can I get only the year part from a date expression
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Year")))->PutComputedField(L"year(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,1,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,2,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,3,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,4,13,00,00).operator DATE());
|
|
588
|
Can I convert the expression to date
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Date")))->PutComputedField(L"date(dbl(%0))");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("-1.98");
var_Items->AddItem("30000.99");
var_Items->AddItem("3561.23");
var_Items->AddItem("1232.34");
|
|
587
|
Can I convert the expression to a number, double or float
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Number + 2")))->PutComputedField(L"dbl(%0)+2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("-1.98");
var_Items->AddItem("0.99");
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
|
|
586
|
How can I display dates in long format
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"LongFormat")))->PutComputedField(L"longdate(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,1,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,2,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,3,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,4,13,00,00).operator DATE());
|
|
585
|
How can I display dates in short format
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"ShortFormat")))->PutComputedField(L"shortdate(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,1,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,2,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,3,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,4,13,00,00).operator DATE());
|
|
584
|
How can I display the time only of a date expression
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Date");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Time")))->PutComputedField(L"'time is:' + time(date(%0))");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,1,10,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,2,11,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,3,12,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,4,13,00,00).operator DATE());
|
|
583
|
Is there any function to display currencies, or money formatted as in the control panel
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Currency")))->PutComputedField(L"currency(dbl(%0))");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
var_Items->AddItem("10000.99");
|
|
582
|
How can I convert the expression to a string so I can look into the date string expression for month's name
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Str")))->PutComputedField(L"str(%0) + ' AA'");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("-1.98");
var_Items->AddItem("0.99");
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
|
|
581
|
Can I display the absolute value or positive part of the number
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Abs")))->PutComputedField(L"abs(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("-1.98");
var_Items->AddItem("0.99");
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
|
|
580
|
Is there any function to get largest number with no fraction part that is not greater than the value
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Floor")))->PutComputedField(L"floor(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("-1.98");
var_Items->AddItem("0.99");
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
|
|
579
|
Is there any function to round the values base on the .5 value
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Round")))->PutComputedField(L"round(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("-1.98");
var_Items->AddItem("0.99");
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
|
|
578
|
How can I get or display the integer part of the cell
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Number");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Int")))->PutComputedField(L"int(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("-1.98");
var_Items->AddItem("0.99");
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
|
|
577
|
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"")))->PutFormatColumn(L"proper(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("root");
var_Items->InsertItem(h,vtMissing,"child child");
var_Items->InsertItem(h,vtMissing,"child child");
var_Items->InsertItem(h,vtMissing,"child child");
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
576
|
Is there any option to display cells in uppercase
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"")))->PutFormatColumn(L"upper(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Root");
var_Items->InsertItem(h,vtMissing,"Child 1");
var_Items->InsertItem(h,vtMissing,"Child 2");
var_Items->InsertItem(h,vtMissing,"Chld 3");
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
575
|
Is there any option to display cells in lowercase
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"")))->PutFormatColumn(L"lower(%0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Root");
var_Items->InsertItem(h,vtMissing,"Child 1");
var_Items->InsertItem(h,vtMissing,"Child 2");
var_Items->InsertItem(h,vtMissing,"Chld 3");
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
574
|
How can I display the column using currency format and enlarge the font for certain values
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Currency")));
var_Column->PutDef(EXGRIDLib::exCellValueFormat,long(1));
var_Column->PutFormatColumn(L"len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("1.23");
var_Items->AddItem("2.34");
var_Items->AddItem("9.94");
var_Items->AddItem("11.94");
var_Items->AddItem("1000");
|
|
573
|
How can I highlight only parts of the cells
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"")));
var_Column->PutDef(EXGRIDLib::exCellValueFormat,long(1));
var_Column->PutFormatColumn(L"value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Root");
var_Items->InsertItem(h,vtMissing,"Child 1");
var_Items->InsertItem(h,vtMissing,"Child 2");
var_Items->InsertItem(h,vtMissing,"Child 3");
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
572
|
How can I get the number of occurrences of a specified string in the cell
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"");
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"occurrences")));
var_Column->PutComputedField(L"lower(%0) count 'o'");
var_Column->PutFormatColumn(L"'contains ' + value + ' of \\'o\\' chars'");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Root");
var_Items->InsertItem(h,vtMissing,"Child 1 oooof the root");
var_Items->InsertItem(h,vtMissing,"Child 2");
var_Items->InsertItem(h,vtMissing,"Child 3");
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
571
|
How can I display dates in my format
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Date")));
var_Column->PutDef(EXGRIDLib::exCellValueFormat,long(1));
var_Column->PutFormatColumn(L"'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,21,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,22,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,13,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,24,0,00,00).operator DATE());
|
|
570
|
How can I display dates in short format
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Date")))->PutFormatColumn(L"shortdate(value)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,1,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,2,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,3,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,4,0,00,00).operator DATE());
|
|
569
|
How can I display dates in long format
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Date")))->PutFormatColumn(L"longdate(value)");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(COleDateTime(2001,1,1,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2002,2,2,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2003,3,3,0,00,00).operator DATE());
var_Items->AddItem(COleDateTime(2004,4,4,0,00,00).operator DATE());
|
|
568
|
How can I display only the right part of the cell
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"");
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Right")));
var_Column->PutComputedField(L"%0 right 2");
var_Column->PutFormatColumn(L"'\"' + value + '\"'");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Root");
var_Items->InsertItem(h,vtMissing,"Child 1");
var_Items->InsertItem(h,vtMissing,"Child 2");
var_Items->InsertItem(h,vtMissing,"SChild 3");
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
567
|
How can I display only the left part of the cell
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Left")))->PutComputedField(L"%0 left 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Root");
var_Items->InsertItem(h,vtMissing,"Child 1");
var_Items->InsertItem(h,vtMissing,"Child 2");
var_Items->InsertItem(h,vtMissing,"SChild 3");
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
566
|
How can I display true or false instead 0 and -1
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Boolean")))->PutFormatColumn(L"value != 0 ? 'true' : 'false'");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(VARIANT_TRUE);
var_Items->AddItem(VARIANT_FALSE);
var_Items->AddItem(VARIANT_TRUE);
var_Items->AddItem(long(0));
var_Items->AddItem(long(1));
|
|
565
|
How can I save data on XML format
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->LoadXML("http://www.exontrol.net/testing.xml");
spGrid1->SaveXML("c:/temp/exgrid.xml");
|
|
564
|
How can I load data on XML format
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->LoadXML("http://www.exontrol.net/testing.xml");
|
|
563
|
I have an EBN file how can I apply different colors to it, so no need to create a new one
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn");
spGrid1->PutSelBackColor(spGrid1->GetBackColor());
spGrid1->PutSelForeColor(spGrid1->GetForeColor());
spGrid1->PutHasLines(EXGRIDLib::exNoLine);
spGrid1->GetColumns()->Add(L"Default");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Root");
long hC = var_Items->InsertItem(h,vtMissing,"Default");
var_Items->PutItemBackColor(hC,0x1000000);
var_Items->PutItemHeight(var_Items->InsertItem(h,vtMissing,""),6);
hC = var_Items->InsertItem(h,vtMissing,"Light Green");
var_Items->PutItemBackColor(hC,0x100ff00);
var_Items->PutItemHeight(var_Items->InsertItem(h,vtMissing,""),6);
hC = var_Items->InsertItem(h,vtMissing,"Dark Green");
var_Items->PutItemBackColor(hC,0x1007f00);
var_Items->PutItemHeight(var_Items->InsertItem(h,vtMissing,""),6);
hC = var_Items->InsertItem(h,vtMissing,"Magenta");
var_Items->PutItemBackColor(hC,0x1ff7fff);
var_Items->PutItemHeight(var_Items->InsertItem(h,vtMissing,""),6);
hC = var_Items->InsertItem(h,vtMissing,"Yellow");
var_Items->PutItemBackColor(hC,0x17fffff);
var_Items->PutItemHeight(var_Items->InsertItem(h,vtMissing,""),6);
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
562
|
How can I change the background color or the visual appearance using ebn for a particular column
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn");
EXGRIDLib::IColumnsPtr var_Columns = spGrid1->GetColumns();
var_Columns->Add(L"Column 1");
((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column 2")))->PutDef(EXGRIDLib::exHeaderBackColor,long(16777216));
((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column 3")))->PutDef(EXGRIDLib::exHeaderBackColor,long(16777471));
var_Columns->Add(L"Column 4");
|
|
561
|
How can I change the foreground color for a particular column
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
EXGRIDLib::IColumnsPtr var_Columns = spGrid1->GetColumns();
var_Columns->Add(L"Column 1");
((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column 2")))->PutDef(EXGRIDLib::exHeaderForeColor,long(8439039));
var_Columns->Add(L"Column 3");
|
|
560
|
How can I change the background color for a particular column
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
EXGRIDLib::IColumnsPtr var_Columns = spGrid1->GetColumns();
var_Columns->Add(L"Column 1");
((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column 2")))->PutDef(EXGRIDLib::exHeaderBackColor,long(8439039));
var_Columns->Add(L"Column 3");
|
|
559
|
Does your control support RightToLeft property for RTL languages or right to left
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->BeginUpdate();
spGrid1->PutScrollBars(EXGRIDLib::exDisableBoth);
spGrid1->PutLinesAtRoot(EXGRIDLib::exLinesAtRoot);
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"P1")));
var_Column->PutDef(EXGRIDLib::exCellHasCheckBox,VARIANT_TRUE);
var_Column->PutPartialCheck(VARIANT_TRUE);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Root");
var_Items->InsertItem(h,vtMissing,"Child 1");
var_Items->InsertItem(h,vtMissing,"Child 2");
var_Items->PutExpandItem(h,VARIANT_TRUE);
spGrid1->PutRightToLeft(VARIANT_TRUE);
spGrid1->EndUpdate();
|
|
558
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->BeginUpdate();
spGrid1->PutScrollBars(EXGRIDLib::exDisableBoth);
EXGRIDLib::IColumnsPtr var_Columns = spGrid1->GetColumns();
var_Columns->Add(L"C1");
var_Columns->Add(L"C2");
var_Columns->Add(L"C3");
var_Columns->Add(L"C4");
var_Columns->Add(L"C5");
var_Columns->Add(L"C6");
var_Columns->Add(L"C7");
var_Columns->Add(L"C8");
spGrid1->PutRightToLeft(VARIANT_TRUE);
spGrid1->EndUpdate();
|
|
557
|
Can I display the cell's check box after the text
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column")));
var_Column->PutDef(EXGRIDLib::exCellHasCheckBox,VARIANT_TRUE);
var_Column->PutDef(EXGRIDLib::exCellDrawPartsOrder,"caption,check");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellHasCheckBox(var_Items->AddItem("Caption 1"),long(0),VARIANT_TRUE);
var_Items->PutCellHasCheckBox(var_Items->AddItem("Caption 2"),long(0),VARIANT_TRUE);
|
|
556
|
Can I change the order of the parts in the cell, as checkbox after the text, and so on
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->Images(_bstr_t("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column")))->PutDef(EXGRIDLib::exCellDrawPartsOrder,"caption,check,icon,icons,picture");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Text");
var_Items->PutCellImage(h,long(0),1);
var_Items->PutCellHasCheckBox(h,long(0),VARIANT_TRUE);
|
|
555
|
Can I have an image displayed after the text. Can I get that effect without using HTML content
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->Images(_bstr_t("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column")))->PutDef(EXGRIDLib::exCellDrawPartsOrder,"caption,icon,check,icons,picture");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Text");
var_Items->PutCellImage(h,long(0),1);
|
|
554
|
How can I display the column's header using multiple lines
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutHeaderHeight(128);
spGrid1->PutHeaderSingleLine(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"This is just a column that should break the header.")))->PutWidth(32);
spGrid1->GetColumns()->Add(L"This is just another column that should break the header.");
|
|
553
|
How can include the values in the inner cells in the drop down filter window
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exRowLines);
spGrid1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn");
spGrid1->PutDescription(EXGRIDLib::exFilterBarBlanks,L"");
spGrid1->PutDescription(EXGRIDLib::exFilterBarNonBlanks,L"");
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Single Column")));
var_Column->PutHTMLCaption(L"Single column with <b>inner cells</b>");
var_Column->PutToolTip(L"Click the drop down filter button, and the filter list includes the inner cells values too.");
var_Column->PutDisplayFilterButton(VARIANT_TRUE);
var_Column->PutDisplayFilterPattern(VARIANT_FALSE);
var_Column->PutFilterList(EXGRIDLib::exIncludeInnerCells);
spGrid1->PutShowFocusRect(VARIANT_FALSE);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
_variant_t s = var_Items->GetSplitCell(var_Items->AddItem("S 1.1"),long(0));
var_Items->PutCellValue(vtMissing,s,"S 1.2");
var_Items->PutCellHAlignment(vtMissing,s,EXGRIDLib::CenterAlignment);
var_Items->PutCellBackColor(vtMissing,s,0x1000000);
var_Items->PutCellWidth(vtMissing,s,84);
s = var_Items->GetSplitCell(var_Items->AddItem("S 2.1"),long(0));
var_Items->PutCellValue(vtMissing,s,"S 2.2");
var_Items->PutCellHAlignment(vtMissing,s,EXGRIDLib::CenterAlignment);
var_Items->PutCellWidth(vtMissing,s,84);
s = var_Items->GetSplitCell(var_Items->AddItem("S 3.1"),long(0));
var_Items->PutCellValue(vtMissing,s,"S 3.2");
var_Items->PutCellHAlignment(vtMissing,s,EXGRIDLib::CenterAlignment);
var_Items->PutCellBackColor(vtMissing,s,0x1000000);
var_Items->PutCellWidth(vtMissing,s,84);
|
|
552
|
How can I sort the value gets listed in the drop down filter window
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutLinesAtRoot(EXGRIDLib::exLinesAtRoot);
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutDescription(EXGRIDLib::exFilterBarAll,L"");
spGrid1->PutDescription(EXGRIDLib::exFilterBarBlanks,L"");
spGrid1->PutDescription(EXGRIDLib::exFilterBarNonBlanks,L"");
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"P1")));
var_Column->PutDisplayFilterButton(VARIANT_TRUE);
var_Column->PutDisplayFilterPattern(VARIANT_FALSE);
var_Column->PutFilterList(EXGRIDLib::exSortItemsDesc);
EXGRIDLib::IColumnPtr var_Column1 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"P2")));
var_Column1->PutDisplayFilterButton(VARIANT_TRUE);
var_Column1->PutDisplayFilterPattern(VARIANT_FALSE);
var_Column1->PutFilterList(EXGRIDLib::exSortItemsAsc);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h = var_Items->AddItem("Z3");
var_Items->PutCellValue(h,long(1),"C");
var_Items->PutCellValue(var_Items->InsertItem(h,vtMissing,"Z1"),long(1),"B");
var_Items->PutCellValue(var_Items->InsertItem(h,vtMissing,"Z2"),long(1),"A");
var_Items->PutExpandItem(h,VARIANT_TRUE);
|
|
551
|
How can I align the text/caption on the scroll bar
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutScrollPartCaption(EXGRIDLib::exHScroll,EXGRIDLib::exLowerBackPart,L"left");
spGrid1->PutScrollPartCaptionAlignment(EXGRIDLib::exHScroll,EXGRIDLib::exLowerBackPart,EXGRIDLib::LeftAlignment);
spGrid1->PutScrollPartCaption(EXGRIDLib::exHScroll,EXGRIDLib::exUpperBackPart,L"right");
spGrid1->PutScrollPartCaptionAlignment(EXGRIDLib::exHScroll,EXGRIDLib::exUpperBackPart,EXGRIDLib::RightAlignment);
spGrid1->PutColumnAutoResize(VARIANT_FALSE);
spGrid1->GetColumns()->Add(L"1");
spGrid1->GetColumns()->Add(L"2");
spGrid1->GetColumns()->Add(L"3");
spGrid1->GetColumns()->Add(L"4");
spGrid1->GetColumns()->Add(L"5");
spGrid1->GetColumns()->Add(L"6");
|
|
550
|
How do I select the next row/item
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetColumns()->Add(L"Column");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem("Item 1");
var_Items->AddItem("Item 2");
var_Items->AddItem("Item 3");
var_Items->PutSelectItem(var_Items->GetNextVisibleItem(var_Items->GetFocusItem()),VARIANT_TRUE);
|
|
549
|
How do I enable resizing ( changing the height ) the items at runtime
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutItemsAllowSizing(EXGRIDLib::exResizeItem);
spGrid1->PutDrawGridLines(EXGRIDLib::exHLines);
spGrid1->PutScrollBySingleLine(VARIANT_TRUE);
spGrid1->GetColumns()->Add(L"Column");
spGrid1->GetItems()->AddItem("Item 1");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutItemHeight(var_Items->AddItem("Item 2"),48);
spGrid1->GetItems()->AddItem("Item 3");
spGrid1->GetItems()->AddItem("Item 4");
|
|
548
|
How do I enable resizing all the items at runtime
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutItemsAllowSizing(EXGRIDLib::exResizeAllItems);
spGrid1->PutDrawGridLines(EXGRIDLib::exHLines);
spGrid1->GetColumns()->Add(L"Column");
spGrid1->GetItems()->AddItem("Item 1");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutItemHeight(var_Items->AddItem("Item 2"),48);
spGrid1->GetItems()->AddItem("Item 3");
|
|
547
|
How can I remove the filter
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column")));
var_Column->PutDisplayFilterButton(VARIANT_TRUE);
var_Column->PutFilterType(EXGRIDLib::exBlanks);
spGrid1->ApplyFilter();
spGrid1->ClearFilter();
|
|
546
|
How can I vertically display the column's caption, in the header
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"A")))->PutHeaderVertical(VARIANT_TRUE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"B")))->PutHeaderVertical(VARIANT_TRUE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"H")))->PutHeaderVertical(VARIANT_FALSE);
|
|
545
|
When I have a column in a grid that is set to having a checkbox, and the grid's singlesel is set to false, I am able to toggle the checkboxes for a while, but lose this functionality eventually. Do you have a tip
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Check")))->PutDef(EXGRIDLib::exCellHasCheckBox,VARIANT_TRUE);
spGrid1->PutSingleSel(VARIANT_FALSE);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(VARIANT_TRUE);
var_Items->AddItem(VARIANT_FALSE);
var_Items->AddItem(VARIANT_FALSE);
|
|
544
|
How do I arrange, format or layout the item on multiple levels or lines, as a subform
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->Images(_bstr_t("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
spGrid1->PutDrawGridLines(EXGRIDLib::exRowLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutItemsAllowSizing(EXGRIDLib::exResizeItem);
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutScrollBySingleLine(VARIANT_TRUE);
spGrid1->PutBackColor(RGB(255,255,255));
spGrid1->PutSelBackColor(RGB(255,255,255));
spGrid1->PutSelForeColor(0x80000012);
EXGRIDLib::IColumnsPtr var_Columns = spGrid1->GetColumns();
var_Columns->Add(L"");
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")));
var_Column->PutVisible(VARIANT_FALSE);
var_Column->GetEditor()->PutEditType(EXGRIDLib::EditType);
EXGRIDLib::IColumnPtr var_Column1 = ((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")));
var_Column1->PutVisible(VARIANT_FALSE);
var_Column1->GetEditor()->PutEditType(EXGRIDLib::DropDownType);
EXGRIDLib::IColumnPtr var_Column2 = ((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")));
var_Column2->PutVisible(VARIANT_FALSE);
var_Column2->GetEditor()->PutEditType(EXGRIDLib::DropDownType);
EXGRIDLib::IColumnPtr var_Column3 = ((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")));
var_Column3->PutVisible(VARIANT_FALSE);
EXGRIDLib::IEditorPtr var_Editor = var_Column3->GetEditor();
var_Editor->PutEditType(EXGRIDLib::CheckValueType);
var_Editor->PutOption(EXGRIDLib::exCheckValue2,long(1));
EXGRIDLib::IColumnPtr var_Column4 = ((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")));
var_Column4->PutVisible(VARIANT_FALSE);
var_Column4->GetEditor()->PutEditType(EXGRIDLib::DateType);
((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column5 = ((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")));
var_Column5->PutVisible(VARIANT_FALSE);
var_Column5->GetEditor()->PutEditType(EXGRIDLib::DropDownType);
EXGRIDLib::IColumnPtr var_Column6 = ((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")));
var_Column6->PutVisible(VARIANT_FALSE);
var_Column6->PutDef(EXGRIDLib::exCellSingleLine,long(0));
var_Editor = var_Column6->GetEditor();
var_Editor->PutEditType(EXGRIDLib::MemoType);
var_Editor->PutButtonWidth(17);
var_Editor->PutOption(EXGRIDLib::exDownArrow,long(0));
var_Editor->PutOption(EXGRIDLib::exEndKey,long(0));
var_Editor->PutOption(EXGRIDLib::exHomeKey,long(0));
var_Editor->PutOption(EXGRIDLib::exLeftArrow,long(0));
var_Editor->PutOption(EXGRIDLib::exMemoAutoSize,long(0));
var_Editor->PutOption(EXGRIDLib::exMemoVScrollBar,long(-1));
var_Editor->PutOption(EXGRIDLib::exPageDownKey,long(0));
var_Editor->PutOption(EXGRIDLib::exPageUpKey,long(0));
var_Editor->PutOption(EXGRIDLib::exRightArrow,long(0));
var_Editor->PutOption(EXGRIDLib::exUpArrow,long(0));
var_Column6->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(var_Columns->Add(L"Column")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h0 = var_Items->AddItem("");
var_Items->PutCellValue(h0,long(9),"Dismiss");
var_Items->PutCellFormatLevel(h0,long(0),_bstr_t("12;\" \"[b=0][bg=RGB(248,248,248)]/(\" \"[b=0][bg=RGB(248,248,248)]:12,(1;\" \"[b=0]/(\" \"[b=0]:1,(25;(5;\" \"[b=0]/((\"Subjec") +
"t:\"[b=0]:80,(1;\" \"[b=0][bg=RGB(0,0,0)]/(\" \"[b=0][bg=RGB(0,0,0)]:1,(\" \"[b=0][bg=RGB(255,0,0)]:5,1[b=0]),\" \"[b=0][bg=RGB(" +
"0,0,0)]:1)/1;\" \"[b=0][bg=RGB(0,0,0)]))/1;\" \"[b=0]))/20;(\"Location:\"[b=0]:80,(1;\" \"[b=0][bg=RGB(0,0,0)]/(\" \"[b=0][bg=RG" +
"B(0,0,0)]:1,2[b=0],\" \"[b=0][bg=RGB(0,0,0)]:1)/1;\" \"[b=0][bg=RGB(0,0,0)]),((\" \"[b=0]:10,\"Label:\"[b=0])):50,(1;\" \"[b=0][" +
"bg=RGB(0,0,0)]/(\" \"[b=0][bg=RGB(0,0,0)]:1,3[b=0],\" \"[b=0][bg=RGB(0,0,0)]:1)/1;\" \"[b=0][bg=RGB(0,0,0)]))/50;(10;\" \"[b=0]/" +
"(1;\" \"[b=0][bg=RGB(255,0,0)]/(\"Recurrence:\"[b=0]:80,\"Occurs every day effective 20/04/2007 from 01:00 to 01:01.\"[b=0])/1;\" +
"" \"[b=0][bg=RGB(255,0,0)])/10;\" \"[b=0])/23;(4[b=0]:20,\"Reminder:\"[b=0]:60,(1;\" \"[b=0][bg=RGB(0,0,0)]/(\" \"[b=0][bg=RGB(0" +
",0,0)]:1,5[b=0],\" \"[b=0][bg=RGB(0,0,0)]:1)/1;\" \"[b=0][bg=RGB(0,0,0)]),((\" \"[b=0]:5,6[b=0])):30,((\" \"[b=0]:10,\"Show time" +
" as:\"[b=0])):90,(1;\" \"[b=0][bg=RGB(0,0,0)]/(\" \"[b=0][bg=RGB(0,0,0)]:1,7[b=0],\" \"[b=0][bg=RGB(0,0,0)]:1)/1;\" \"[b=0][bg=R" +
"GB(0,0,0)]))/(12;\" \"[b=0]/(1;\" \"[b=0][bg=RGB(0,0,0)]/(\" \"[b=0][bg=RGB(0,0,0)]:1,8[b=0],\" \"[b=0][bg=RGB(0,0,0)]:1)/1;\" \" +
""[b=0][bg=RGB(0,0,0)]))/35;(5;\" \"[b=0]/(\" \"[b=0],\" \"[b=0],((\" \"[b=0]:40,9[b=0])))/5;\" \"[b=0])),\" \"[b=0]:1)/1;\" \"[b" +
"=0]),\" \"[b=0][bg=RGB(248,248,248)]:12)/12;\" \"[b=0][bg=RGB(248,248,248)]");
var_Items->PutCellHasCheckBox(h0,long(4),VARIANT_TRUE);
var_Items->PutCellHasButton(h0,long(9),VARIANT_TRUE);
var_Items->PutCellHAlignment(h0,long(9),EXGRIDLib::CenterAlignment);
var_Items->PutCellVAlignment(h0,long(8),EXGRIDLib::exTop);
var_Items->PutCellForeColor(h0,long(8),RGB(0,0,0));
var_Items->PutCellHasButton(h0,long(6),VARIANT_TRUE);
var_Items->PutCellValue(h0,long(6),"<img>1</img>");
var_Items->PutCellValueFormat(h0,long(6),EXGRIDLib::exHTML);
var_Items->PutCellHAlignment(h0,long(6),EXGRIDLib::CenterAlignment);
var_Items->PutItemHeight(h0,296);
|
|
543
|
How do I arrange, format or layout the item on multiple levels or lines
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutDefaultItemHeight(34);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"1")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"2")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"3")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"4")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"5")))->PutVisible(VARIANT_FALSE);
spGrid1->GetColumns()->Add(L"General");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutDefaultItem(var_Items->AddItem(long(0)));
var_Items->PutCellValue(long(0),long(1),long(1));
var_Items->PutCellValue(long(0),long(2),long(2));
var_Items->PutCellValue(long(0),long(3),long(3));
var_Items->PutCellValue(long(0),long(4),long(4));
var_Items->PutCellFormatLevel(var_Items->GetDefaultItem(),long(5),L"0,1,2/3,4");
var_Items->PutDefaultItem(var_Items->AddItem(long(5)));
var_Items->PutCellValue(long(0),long(1),long(6));
var_Items->PutCellValue(long(0),long(2),long(7));
var_Items->PutCellValue(long(0),long(3),long(8));
var_Items->PutCellValue(long(0),long(4),long(9));
var_Items->PutCellFormatLevel(var_Items->GetDefaultItem(),long(5),L"3,4/0,1,2");
|
|
542
|
How do I arrange, format or layout the column's header on multiple levels or lines
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"1")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"2")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"3")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"4")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"5")))->PutVisible(VARIANT_FALSE);
spGrid1->PutHeaderHeight(32);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"General")))->PutFormatLevel(L"0,1,2/3,4");
|
|
541
|
How do I arrange, format or layout the item on multiple levels or lines
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutDefaultItemHeight(53);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"EmployeeID")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"LastName")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"FirstName")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Handler")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Title")));
var_Column->PutVisible(VARIANT_FALSE);
var_Column->PutDisplayFilterButton(VARIANT_TRUE);
EXGRIDLib::IColumnPtr var_Column1 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"TitleOfCourtesy")));
var_Column1->PutVisible(VARIANT_FALSE);
var_Column1->PutDisplayFilterButton(VARIANT_TRUE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"BirthDate")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"HideDate")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Address")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"City")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Region")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"PostCode")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Country")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"HomePage")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Extension")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column2 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Photo")));
var_Column2->PutVisible(VARIANT_FALSE);
EXGRIDLib::IEditorPtr var_Editor = var_Column2->GetEditor();
var_Editor->PutDropDownVisible(VARIANT_FALSE);
var_Editor->PutEditType(EXGRIDLib::PictureType);
var_Editor->PutOption(EXGRIDLib::exShowPictureType,long(0));
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Notes")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"ReportsTo")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column3 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Personal Info")));
var_Column3->PutDef(EXGRIDLib::exCellFormatLevel,"15:54,(2/1/4)");
var_Column3->PutFormatLevel(L"18;18/(15:54,(2/1/4))");
var_Column3->PutWidth(196);
EXGRIDLib::IColumnPtr var_Column4 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"General Info")));
var_Column4->PutDef(EXGRIDLib::exCellFormatLevel,"(8/18;5):128,((((13/11/12),(6/7/10)),16))");
var_Column4->PutFormatLevel(L"18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
var_Column4->PutWidth(512);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h0 = var_Items->AddItem(long(1));
var_Items->PutCellValue(h0,long(1),"Davolio");
var_Items->PutCellValue(h0,long(2),"Nancy");
var_Items->PutCellValue(h0,long(3),long(0));
var_Items->PutCellValue(h0,long(4),"Sales Representative");
var_Items->PutCellValue(h0,long(5),"Ms.");
var_Items->PutCellValue(h0,long(6),"12/8/1948");
var_Items->PutCellValue(h0,long(7),"5/1/1992");
var_Items->PutCellValue(h0,long(8),"507-20th Ave. \\r\\nE.Apt. 2A");
var_Items->PutCellValue(h0,long(9),"Seattle");
var_Items->PutCellValue(h0,long(10),"WA");
var_Items->PutCellValue(h0,long(11),"98122");
var_Items->PutCellValue(h0,long(12),"USA");
var_Items->PutCellValue(h0,long(13),"(206) 555-9857");
var_Items->PutCellValue(h0,long(14),"5467");
var_Items->PutCellValue(h0,long(15),((IDispatch*)(spGrid1->ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\sample.bmp`)"))));
var_Items->PutCellValue(h0,long(16),_bstr_t("Education includes a BA in psychology from Colorado State University in 1970. She also completed \"The Art of the Cold Call.\"") +
" Nancy is a member of ToastmastersInternational.");
var_Items->PutCellValue(h0,long(17),long(2));
spGrid1->PutItems(spGrid1->GetItems(long(0)),vtMissing);
EXGRIDLib::IItemsPtr var_Items1 = spGrid1->GetItems();
var_Items1->PutCellFormatLevel(var_Items1->GetFocusItem(),"General Info",L"15,10,4");
var_Items1->PutCellFormatLevel(var_Items1->GetFocusItem(),"Personal Info",L"1/2");
|
|
540
|
How do I arrange, format or layout the data on multiple levels or lines
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutDefaultItemHeight(53);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"EmployeeID")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"LastName")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"FirstName")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Handler")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Title")));
var_Column->PutVisible(VARIANT_FALSE);
var_Column->PutDisplayFilterButton(VARIANT_TRUE);
EXGRIDLib::IColumnPtr var_Column1 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"TitleOfCourtesy")));
var_Column1->PutVisible(VARIANT_FALSE);
var_Column1->PutDisplayFilterButton(VARIANT_TRUE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"BirthDate")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"HideDate")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Address")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"City")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Region")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"PostCode")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Country")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"HomePage")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Extension")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column2 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Photo")));
var_Column2->PutVisible(VARIANT_FALSE);
EXGRIDLib::IEditorPtr var_Editor = var_Column2->GetEditor();
var_Editor->PutDropDownVisible(VARIANT_FALSE);
var_Editor->PutEditType(EXGRIDLib::PictureType);
var_Editor->PutOption(EXGRIDLib::exShowPictureType,long(0));
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Notes")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"ReportsTo")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column3 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Personal Info")));
var_Column3->PutDef(EXGRIDLib::exCellFormatLevel,"15:54,(2/1/4)");
var_Column3->PutFormatLevel(L"18;18/(15:54,(2/1/4))");
var_Column3->PutWidth(196);
EXGRIDLib::IColumnPtr var_Column4 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"General Info")));
var_Column4->PutDef(EXGRIDLib::exCellFormatLevel,"(8/18;5):128,((((13/11/12),(6/7/10)),16))");
var_Column4->PutFormatLevel(L"18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
var_Column4->PutWidth(512);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
long h0 = var_Items->AddItem(long(1));
var_Items->PutCellValue(h0,long(1),"Davolio");
var_Items->PutCellValue(h0,long(2),"Nancy");
var_Items->PutCellValue(h0,long(3),long(0));
var_Items->PutCellValue(h0,long(4),"Sales Representative");
var_Items->PutCellValue(h0,long(5),"Ms.");
var_Items->PutCellValue(h0,long(6),"12/8/1948");
var_Items->PutCellValue(h0,long(7),"5/1/1992");
var_Items->PutCellValue(h0,long(8),"507-20th Ave. \\r\\nE.Apt. 2A");
var_Items->PutCellValue(h0,long(9),"Seattle");
var_Items->PutCellValue(h0,long(10),"WA");
var_Items->PutCellValue(h0,long(11),"98122");
var_Items->PutCellValue(h0,long(12),"USA");
var_Items->PutCellValue(h0,long(13),"(206) 555-9857");
var_Items->PutCellValue(h0,long(14),"5467");
var_Items->PutCellValue(h0,long(15),((IDispatch*)(spGrid1->ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\sample.bmp`)"))));
var_Items->PutCellValue(h0,long(16),_bstr_t("Education includes a BA in psychology from Colorado State University in 1970. She also completed \"The Art of the Cold Call.\"") +
" Nancy is a member of ToastmastersInternational.");
var_Items->PutCellValue(h0,long(17),long(2));
spGrid1->PutItems(spGrid1->GetItems(long(0)),vtMissing);
spGrid1->PutItems(spGrid1->GetItems(long(0)),vtMissing);
spGrid1->PutItems(spGrid1->GetItems(long(0)),vtMissing);
|
|
539
|
How do I arrange, format or layout the column's data on multiple levels or lines
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutDefaultItemHeight(68);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"EmployeeID")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"LastName")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"FirstName")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Handler")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Title")));
var_Column->PutVisible(VARIANT_FALSE);
var_Column->PutDisplayFilterButton(VARIANT_TRUE);
EXGRIDLib::IColumnPtr var_Column1 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"TitleOfCourtesy")));
var_Column1->PutVisible(VARIANT_FALSE);
var_Column1->PutDisplayFilterButton(VARIANT_TRUE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"BirthDate")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"HideDate")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Address")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"City")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Region")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"PostCode")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Country")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"HomePage")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Extension")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Photo")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Notes")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"ReportsTo")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column2 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Personal Info")));
var_Column2->PutDef(EXGRIDLib::exCellFormatLevel,"18;18/(15:54,(2/1/4))");
var_Column2->PutFormatLevel(L"18;18/(15:54,(2/1/4))");
var_Column2->PutWidth(196);
EXGRIDLib::IColumnPtr var_Column3 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"General Info")));
var_Column3->PutDef(EXGRIDLib::exCellFormatLevel,"18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
var_Column3->PutFormatLevel(L"18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
var_Column3->PutWidth(512);
spGrid1->GetItems()->AddItem("");
spGrid1->GetItems()->AddItem("");
spGrid1->GetItems()->AddItem("");
spGrid1->GetItems()->AddItem("");
|
|
538
|
How do I arrange, format or layout the column's header on multiple levels or lines
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"EmployeeID")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"LastName")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"FirstName")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Handler")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Title")));
var_Column->PutVisible(VARIANT_FALSE);
var_Column->PutDisplayFilterButton(VARIANT_TRUE);
EXGRIDLib::IColumnPtr var_Column1 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"TitleOfCourtesy")));
var_Column1->PutVisible(VARIANT_FALSE);
var_Column1->PutDisplayFilterButton(VARIANT_TRUE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"BirthDate")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"HideDate")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Address")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"City")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Region")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"PostCode")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Country")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"HomePage")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Extension")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Photo")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Notes")))->PutVisible(VARIANT_FALSE);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"ReportsTo")))->PutVisible(VARIANT_FALSE);
EXGRIDLib::IColumnPtr var_Column2 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Personal Info")));
var_Column2->PutFormatLevel(L"18;18/(15:54,(2/1/4))");
var_Column2->PutWidth(196);
EXGRIDLib::IColumnPtr var_Column3 = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"General Info")));
var_Column3->PutFormatLevel(L"18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
var_Column3->PutWidth(512);
|
|
537
|
How can I select a cells like in excel
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutSingleSel(VARIANT_FALSE);
spGrid1->PutFullRowSelect(EXGRIDLib::exRectSel);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column1")))->PutSelected(VARIANT_TRUE);
spGrid1->GetColumns()->Add(L"Column2");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column3")))->PutSelected(VARIANT_TRUE);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutDefaultItem(var_Items->AddItem(long(0)));
var_Items->PutCellValue(long(0),long(1),long(1));
var_Items->PutCellValue(long(0),long(2),long(2));
var_Items->PutDefaultItem(var_Items->AddItem(long(3)));
var_Items->PutCellValue(long(0),long(1),long(4));
var_Items->PutCellValue(long(0),long(2),long(5));
var_Items->PutDefaultItem(var_Items->AddItem(long(6)));
var_Items->PutCellValue(long(0),long(1),long(7));
var_Items->PutCellValue(long(0),long(2),long(8));
|
|
536
|
How can I select a multiple column
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutSingleSel(VARIANT_FALSE);
spGrid1->PutFullRowSelect(EXGRIDLib::exRectSel);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column1")))->PutSelected(VARIANT_TRUE);
spGrid1->GetColumns()->Add(L"Column2");
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column3")))->PutSelected(VARIANT_TRUE);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutDefaultItem(var_Items->AddItem(long(0)));
var_Items->PutCellValue(long(0),long(1),long(1));
var_Items->PutCellValue(long(0),long(2),long(2));
var_Items->PutDefaultItem(var_Items->AddItem(long(3)));
var_Items->PutCellValue(long(0),long(1),long(4));
var_Items->PutCellValue(long(0),long(2),long(5));
var_Items->PutDefaultItem(var_Items->AddItem(long(6)));
var_Items->PutCellValue(long(0),long(1),long(7));
var_Items->PutCellValue(long(0),long(2),long(8));
spGrid1->GetItems()->SelectAll();
|
|
535
|
How can I select a column
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutMarkSearchColumn(VARIANT_FALSE);
spGrid1->PutSingleSel(VARIANT_FALSE);
spGrid1->PutFullRowSelect(EXGRIDLib::exRectSel);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column1")))->PutSelected(VARIANT_TRUE);
spGrid1->GetColumns()->Add(L"Column2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("One"),long(1),"One");
EXGRIDLib::IItemsPtr var_Items1 = spGrid1->GetItems();
var_Items1->PutCellValue(var_Items1->AddItem("Two"),long(1),"Two");
spGrid1->GetItems()->SelectAll();
|
|
534
|
How can I collapse all cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(64));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Expanded");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->CollapseAllCards();
|
|
533
|
How can I expand all cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(64));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Expanded");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->ExpandAllCards();
|
|
532
|
How can I expand or collapse a card
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(64));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Expanded");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
531
|
How can I format or arrange the data being displayed in the card
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutHasButtons(EXGRIDLib::exNoButtons);
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutItemsAllowSizing(EXGRIDLib::exResizeItem);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewTitleFormat,"(\"Title:\",0),1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewWidth,long(164));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(18));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
530
|
How can I format or arrange the data being displayed in the card
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutItemsAllowSizing(EXGRIDLib::exResizeItem);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"(\"ABC\",2)/(0,3,\"DEFGH\")/1/0/1/0/1/1,0[bg=RGB(230,230,230)][fg=RGB(255,0,0)");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewTitleFormat,"");
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
529
|
How can I hide the tilte for the cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutItemsAllowSizing(EXGRIDLib::exResizeItem);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"0/1/0/1/0/1/0/1,0");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewTitleFormat,"");
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
528
|
How can I display resizing lines between cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutItemsAllowSizing(EXGRIDLib::exResizeItem);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewVResizeLine,VARIANT_TRUE);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHResizeLine,VARIANT_TRUE);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBorderWidth,long(8));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBorderHeight,long(8));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
527
|
How can edit the text in the card
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(64));
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column 1")))->GetEditor()->PutEditType(EXGRIDLib::EditType);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Column 2")))->GetEditor()->PutEditType(EXGRIDLib::EditType);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
526
|
How can I change the height of the card
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(64));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
525
|
How can I display the cards from top to bottom
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewLeftToRight,VARIANT_FALSE);
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
524
|
How do I change the background color for a specified card
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
var_Items->PutItemForeColor(var_Items->GetFocusItem(),RGB(255,0,0));
|
|
523
|
How do I change the visual aspect for a specified card
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn");
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
var_Items->PutItemBackColor(var_Items->GetFocusItem(),0x1000000);
|
|
522
|
How do I change the background color for a specified card
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
var_Items->PutItemBackColor(var_Items->GetFocusItem(),RGB(255,0,0));
|
|
521
|
Is there any way to specify the foreground color for the title of the cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewTitleForeColor,long(255));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
520
|
Is there any way to specify the foreground color for all cards, including its title
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutForeColor(RGB(255,0,0));
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
519
|
How can I change the visual appearance for all cards, including the title
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn");
spGrid1->GetVisualAppearance()->Add(2,"c:\\exontrol\\images\\pushed.ebn");
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBackColor,long(16777216));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewTitleBackColor,long(33554432));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
518
|
Is there any way to specify the background color for all cards, including its title
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBackColor,long(255));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewTitleBackColor,long(128));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
517
|
Is there any way to specify the background color for all cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBackColor,long(255));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
516
|
How can I specify the distance between cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBorderWidth,long(16));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBorderHeight,long(16));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
515
|
How can I resize the cards at runtime
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutItemsAllowSizing(EXGRIDLib::exResizeItem);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewVResizeLine,VARIANT_TRUE);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHResizeLine,VARIANT_TRUE);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBorderWidth,long(8));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewBorderHeight,long(8));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
var_Items->PutExpandCard(var_Items->GetFocusItem(),VARIANT_TRUE);
|
|
514
|
How can show the grid lines for my cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
513
|
How can I hide the +/- expanding / collapsing buttons in the cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutExpandOnDblClick(VARIANT_FALSE);
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
512
|
How can I hide the +/- expanding / collapsing buttons in the cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutHasButtons(EXGRIDLib::exNoButtons);
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
511
|
Is there any way to to specify the number of cards being displayed from letf to right
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewColumns,long(3));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
510
|
Is there any way to to specify the width of the cards, so they fit the control's client area
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewWidth,long(0));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewColumns,long(2));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
509
|
Is there any way to to specify the width of the cards, so they fit the control's client area
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewWidth,long(0));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
508
|
Is there any way to to specify the width of the cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewWidth,long(64));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
507
|
Is there any way to indent the control's data relative to the borders or the frame of the control
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutHeaderVisible(VARIANT_FALSE);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exBorderWidth,long(8));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exBorderHeight,long(8));
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
506
|
Is there any way to indent the control's data relative to the borders or the frame of the control
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutViewMode(EXGRIDLib::exTableView);
spGrid1->PutViewModeOption(EXGRIDLib::exTableView,EXGRIDLib::exBorderWidth,long(8));
spGrid1->PutViewModeOption(EXGRIDLib::exTableView,EXGRIDLib::exBorderHeight,long(8));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Item 1"),long(1),"Item 1.1");
var_Items->PutCellValue(var_Items->AddItem("Item 2"),long(1),"Item 1.2");
var_Items->PutCellValue(var_Items->AddItem("Item 3"),long(1),"Item 1.3");
|
|
505
|
How can I display my rows or items as a table
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutViewMode(EXGRIDLib::exTableView);
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Item 1"),long(1),"Item 1.1");
var_Items->PutCellValue(var_Items->AddItem("Item 2"),long(1),"Item 1.2");
var_Items->PutCellValue(var_Items->AddItem("Item 3"),long(1),"Item 1.3");
|
|
504
|
How can I display my rows as cards
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDrawGridLines(EXGRIDLib::exAllLines);
spGrid1->PutViewMode(EXGRIDLib::exCardView);
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewFormat,"1");
spGrid1->PutViewModeOption(EXGRIDLib::exCardView,EXGRIDLib::exCardViewHeight,long(36));
spGrid1->GetColumns()->Add(L"Column 1");
spGrid1->GetColumns()->Add(L"Column 2");
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem("Card 1"),long(1),"Card 1.1");
var_Items->PutCellValue(var_Items->AddItem("Card 2"),long(1),"Card 1.2");
var_Items->PutCellValue(var_Items->AddItem("Card 3"),long(1),"Card 1.3");
|
|
503
|
How can I avoid focusing a new cell, when user presses an arrow, page, home or end key, while the editor is opened
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->PutDefaultEditorOption(EXGRIDLib::exLeftArrow,long(0));
spGrid1->PutDefaultEditorOption(EXGRIDLib::exRightArrow,long(0));
spGrid1->PutDefaultEditorOption(EXGRIDLib::exUpArrow,long(0));
spGrid1->PutDefaultEditorOption(EXGRIDLib::exDownArrow,long(0));
spGrid1->PutDefaultEditorOption(EXGRIDLib::exHomeKey,long(0));
spGrid1->PutDefaultEditorOption(EXGRIDLib::exEndKey,long(0));
spGrid1->PutDefaultEditorOption(EXGRIDLib::exPageUpKey,long(0));
spGrid1->PutDefaultEditorOption(EXGRIDLib::exPageDownKey,long(0));
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Edit")))->GetEditor()->PutEditType(EXGRIDLib::EditType);
((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Edit")))->GetEditor()->PutEditType(EXGRIDLib::EditType);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->PutCellValue(var_Items->AddItem(long(0)),long(1),long(1));
EXGRIDLib::IItemsPtr var_Items1 = spGrid1->GetItems();
var_Items1->PutCellValue(var_Items1->AddItem(long(2)),long(1),long(3));
|
|
502
|
How can I expand predefined items in a drop down list editor as I type
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->Images(_bstr_t("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXGRIDLib::IColumnPtr var_Column = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"DropDown")));
var_Column->PutDef(EXGRIDLib::exCellValueFormat,long(1));
EXGRIDLib::IEditorPtr var_Editor = var_Column->GetEditor();
var_Editor->PutOption(EXGRIDLib::exExpandOnSearch,VARIANT_TRUE);
var_Editor->PutEditType(EXGRIDLib::DropDownListType);
var_Editor->PutDropDownAutoWidth(EXGRIDLib::exDropDownEditorWidth);
var_Editor->AddItem(1,L"<b>CObject</b> class",long(1));
var_Editor->InsertItem(2,L"<b>CCmdTarget</b> class",long(2),long(1));
var_Editor->InsertItem(3,L"<b>CWnd</b> class",long(3),long(2));
var_Editor->InsertItem(6,L"<bgcolor=10A0E0><fgcolor=F0F0F0>S y n c</fgcolor>",long(1),long(1));
var_Editor->AddItem(4,L"Exceptions",long(1));
var_Editor->InsertItem(7,L"<b>System</b> Exceptions",long(2),long(4));
var_Editor->AddItem(5,L"File Services",long(2));
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(long(1));
var_Items->AddItem(long(2));
|
|
501
|
How can I add an extra button to a date picker editor
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXGRIDLib' for the library: 'ExGrid 1.0 Control Library'
#import <ExGrid.dll>
using namespace EXGRIDLib;
*/
EXGRIDLib::IGridPtr spGrid1 = GetDlgItem(IDC_GRID1)->GetControlUnknown();
spGrid1->Images(_bstr_t("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
spGrid1->PutDefaultItemHeight(20);
EXGRIDLib::IEditorPtr var_Editor = ((EXGRIDLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Date")))->GetEditor();
var_Editor->PutEditType(EXGRIDLib::DateType);
var_Editor->AddButton("B1",long(2),long(1),"This is a bit of text that's shown when the cursor hovers the button B1",vtMissing,vtMissing);
var_Editor->PutButtonWidth(20);
EXGRIDLib::IItemsPtr var_Items = spGrid1->GetItems();
var_Items->AddItem(long(0));
var_Items->AddItem(long(1));
|